﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmShpChargeTradingLog" targetNamespace="http://tempuri.org/CDmShpChargeTradingLog.xsd" xmlns:mstns="http://tempuri.org/CDmShpChargeTradingLog.xsd" xmlns="http://tempuri.org/CDmShpChargeTradingLog.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="msBscConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="msBscConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.msBscConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="msBscConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="msBscConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.msBscConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SHP_CHARGE_TRADING_LOGTableAdapter" GeneratorDataComponentClassName="SHP_CHARGE_TRADING_LOGTableAdapter" Name="SHP_CHARGE_TRADING_LOG" UserDataComponentName="SHP_CHARGE_TRADING_LOGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="msBscConnectionString1 (Settings)" DbObjectName="msBsc.dbo.SHP_CHARGE_TRADING_LOG" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SHP_CHARGE_TRADING_LOG] WHERE (([CHARGE_TRADING_ID] = @Original_CHARGE_TRADING_ID) AND ((@IsNull_AR_FREIGHT_ID = 1 AND [AR_FREIGHT_ID] IS NULL) OR ([AR_FREIGHT_ID] = @Original_AR_FREIGHT_ID)) AND ((@IsNull_ACCOUNT_NO = 1 AND [ACCOUNT_NO] IS NULL) OR ([ACCOUNT_NO] = @Original_ACCOUNT_NO)) AND ((@IsNull_ACCOUNT_NME = 1 AND [ACCOUNT_NME] IS NULL) OR ([ACCOUNT_NME] = @Original_ACCOUNT_NME)) AND ((@IsNull_USER_TYPE_CID = 1 AND [USER_TYPE_CID] IS NULL) OR ([USER_TYPE_CID] = @Original_USER_TYPE_CID)) AND ((@IsNull_PAY_DIR = 1 AND [PAY_DIR] IS NULL) OR ([PAY_DIR] = @Original_PAY_DIR)) AND ([TRADING_NO] = @Original_TRADING_NO) AND ([TRADING_NME] = @Original_TRADING_NME) AND ((@IsNull_TRADING_TYPE_CID = 1 AND [TRADING_TYPE_CID] IS NULL) OR ([TRADING_TYPE_CID] = @Original_TRADING_TYPE_CID)) AND ((@IsNull_ALIPAY_TRADING_NO = 1 AND [ALIPAY_TRADING_NO] IS NULL) OR ([ALIPAY_TRADING_NO] = @Original_ALIPAY_TRADING_NO)) AND ((@IsNull_OTH_ACCOUNT_NO = 1 AND [OTH_ACCOUNT_NO] IS NULL) OR ([OTH_ACCOUNT_NO] = @Original_OTH_ACCOUNT_NO)) AND ((@IsNull_OTH_ACCOUNT_NME = 1 AND [OTH_ACCOUNT_NME] IS NULL) OR ([OTH_ACCOUNT_NME] = @Original_OTH_ACCOUNT_NME)) AND ((@IsNull_CHARGE_SRC_CID = 1 AND [CHARGE_SRC_CID] IS NULL) OR ([CHARGE_SRC_CID] = @Original_CHARGE_SRC_CID)) AND ((@IsNull_TRADING_AMT = 1 AND [TRADING_AMT] IS NULL) OR ([TRADING_AMT] = @Original_TRADING_AMT)) AND ((@IsNull_TRADING_SID = 1 AND [TRADING_SID] IS NULL) OR ([TRADING_SID] = @Original_TRADING_SID)) AND ((@IsNull_TRADING_DESC = 1 AND [TRADING_DESC] IS NULL) OR ([TRADING_DESC] = @Original_TRADING_DESC)) AND ((@IsNull_SUBMIT_PAY_DT = 1 AND [SUBMIT_PAY_DT] IS NULL) OR ([SUBMIT_PAY_DT] = @Original_SUBMIT_PAY_DT)) AND ((@IsNull_PAY_ARRIVE_DT = 1 AND [PAY_ARRIVE_DT] IS NULL) OR ([PAY_ARRIVE_DT] = @Original_PAY_ARRIVE_DT)) AND ((@IsNull_PAY_AFTER_SQL = 1 AND [PAY_AFTER_SQL] IS NULL) OR ([PAY_AFTER_SQL] = @Original_PAY_AFTER_SQL)) AND ((@IsNull_IS_SPLIT = 1 AND [IS_SPLIT] IS NULL) OR ([IS_SPLIT] = @Original_IS_SPLIT)) AND ((@IsNull_INITIAL_DT = 1 AND [INITIAL_DT] IS NULL) OR ([INITIAL_DT] = @Original_INITIAL_DT)) AND ((@IsNull_INITIAL_USR = 1 AND [INITIAL_USR] IS NULL) OR ([INITIAL_USR] = @Original_INITIAL_USR)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHARGE_TRADING_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AR_FREIGHT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AR_FREIGHT_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AR_FREIGHT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AR_FREIGHT_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_USER_TYPE_CID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="USER_TYPE_CID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_USER_TYPE_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="USER_TYPE_CID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAY_DIR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAY_DIR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_TYPE_CID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_TYPE_CID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_TYPE_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_TYPE_CID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALIPAY_TRADING_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALIPAY_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OTH_ACCOUNT_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OTH_ACCOUNT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OTH_ACCOUNT_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OTH_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHARGE_SRC_CID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_SRC_CID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHARGE_SRC_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_SRC_CID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TRADING_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_SID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_SID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_SID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_SID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_DESC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SUBMIT_PAY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SUBMIT_PAY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_SUBMIT_PAY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SUBMIT_PAY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAY_ARRIVE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAY_ARRIVE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PAY_ARRIVE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PAY_ARRIVE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAY_AFTER_SQL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAY_AFTER_SQL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAY_AFTER_SQL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_AFTER_SQL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_SPLIT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_SPLIT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_SPLIT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_SPLIT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_USR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SHP_CHARGE_TRADING_LOG] ([CHARGE_TRADING_ID], [AR_FREIGHT_ID], [ACCOUNT_NO], [ACCOUNT_NME], [USER_TYPE_CID], [PAY_DIR], [TRADING_NO], [TRADING_NME], [TRADING_TYPE_CID], [ALIPAY_TRADING_NO], [OTH_ACCOUNT_NO], [OTH_ACCOUNT_NME], [CHARGE_SRC_CID], [TRADING_AMT], [TRADING_SID], [TRADING_DESC], [SUBMIT_PAY_DT], [PAY_ARRIVE_DT], [PAY_AFTER_SQL], [IS_SPLIT], [INITIAL_DT], [INITIAL_USR]) VALUES (@CHARGE_TRADING_ID, @AR_FREIGHT_ID, @ACCOUNT_NO, @ACCOUNT_NME, @USER_TYPE_CID, @PAY_DIR, @TRADING_NO, @TRADING_NME, @TRADING_TYPE_CID, @ALIPAY_TRADING_NO, @OTH_ACCOUNT_NO, @OTH_ACCOUNT_NME, @CHARGE_SRC_CID, @TRADING_AMT, @TRADING_SID, @TRADING_DESC, @SUBMIT_PAY_DT, @PAY_ARRIVE_DT, @PAY_AFTER_SQL, @IS_SPLIT, @INITIAL_DT, @INITIAL_USR);
SELECT CHARGE_TRADING_ID, AR_FREIGHT_ID, ACCOUNT_NO, ACCOUNT_NME, USER_TYPE_CID, PAY_DIR, TRADING_NO, TRADING_NME, TRADING_TYPE_CID, ALIPAY_TRADING_NO, OTH_ACCOUNT_NO, OTH_ACCOUNT_NME, CHARGE_SRC_CID, TRADING_AMT, TRADING_SID, TRADING_DESC, SUBMIT_PAY_DT, PAY_ARRIVE_DT, PAY_AFTER_SQL, IS_SPLIT, INITIAL_DT, INITIAL_USR FROM SHP_CHARGE_TRADING_LOG WHERE (CHARGE_TRADING_ID = @CHARGE_TRADING_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHARGE_TRADING_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AR_FREIGHT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AR_FREIGHT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@USER_TYPE_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="USER_TYPE_CID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAY_DIR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_TYPE_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_TYPE_CID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALIPAY_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OTH_ACCOUNT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OTH_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHARGE_SRC_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_SRC_CID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TRADING_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_SID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_SID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SUBMIT_PAY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SUBMIT_PAY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PAY_ARRIVE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PAY_ARRIVE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAY_AFTER_SQL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_AFTER_SQL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_SPLIT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_SPLIT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CHARGE_TRADING_ID, AR_FREIGHT_ID, ACCOUNT_NO, ACCOUNT_NME, USER_TYPE_CID, PAY_DIR, TRADING_NO, TRADING_NME, TRADING_TYPE_CID, ALIPAY_TRADING_NO, OTH_ACCOUNT_NO, OTH_ACCOUNT_NME, CHARGE_SRC_CID, TRADING_AMT, TRADING_SID, TRADING_DESC, SUBMIT_PAY_DT, PAY_ARRIVE_DT, PAY_AFTER_SQL, IS_SPLIT, INITIAL_DT, INITIAL_USR FROM dbo.SHP_CHARGE_TRADING_LOG</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SHP_CHARGE_TRADING_LOG] SET [CHARGE_TRADING_ID] = @CHARGE_TRADING_ID, [AR_FREIGHT_ID] = @AR_FREIGHT_ID, [ACCOUNT_NO] = @ACCOUNT_NO, [ACCOUNT_NME] = @ACCOUNT_NME, [USER_TYPE_CID] = @USER_TYPE_CID, [PAY_DIR] = @PAY_DIR, [TRADING_NO] = @TRADING_NO, [TRADING_NME] = @TRADING_NME, [TRADING_TYPE_CID] = @TRADING_TYPE_CID, [ALIPAY_TRADING_NO] = @ALIPAY_TRADING_NO, [OTH_ACCOUNT_NO] = @OTH_ACCOUNT_NO, [OTH_ACCOUNT_NME] = @OTH_ACCOUNT_NME, [CHARGE_SRC_CID] = @CHARGE_SRC_CID, [TRADING_AMT] = @TRADING_AMT, [TRADING_SID] = @TRADING_SID, [TRADING_DESC] = @TRADING_DESC, [SUBMIT_PAY_DT] = @SUBMIT_PAY_DT, [PAY_ARRIVE_DT] = @PAY_ARRIVE_DT, [PAY_AFTER_SQL] = @PAY_AFTER_SQL, [IS_SPLIT] = @IS_SPLIT, [INITIAL_DT] = @INITIAL_DT, [INITIAL_USR] = @INITIAL_USR WHERE (([CHARGE_TRADING_ID] = @Original_CHARGE_TRADING_ID) AND ((@IsNull_AR_FREIGHT_ID = 1 AND [AR_FREIGHT_ID] IS NULL) OR ([AR_FREIGHT_ID] = @Original_AR_FREIGHT_ID)) AND ((@IsNull_ACCOUNT_NO = 1 AND [ACCOUNT_NO] IS NULL) OR ([ACCOUNT_NO] = @Original_ACCOUNT_NO)) AND ((@IsNull_ACCOUNT_NME = 1 AND [ACCOUNT_NME] IS NULL) OR ([ACCOUNT_NME] = @Original_ACCOUNT_NME)) AND ((@IsNull_USER_TYPE_CID = 1 AND [USER_TYPE_CID] IS NULL) OR ([USER_TYPE_CID] = @Original_USER_TYPE_CID)) AND ((@IsNull_PAY_DIR = 1 AND [PAY_DIR] IS NULL) OR ([PAY_DIR] = @Original_PAY_DIR)) AND ([TRADING_NO] = @Original_TRADING_NO) AND ([TRADING_NME] = @Original_TRADING_NME) AND ((@IsNull_TRADING_TYPE_CID = 1 AND [TRADING_TYPE_CID] IS NULL) OR ([TRADING_TYPE_CID] = @Original_TRADING_TYPE_CID)) AND ((@IsNull_ALIPAY_TRADING_NO = 1 AND [ALIPAY_TRADING_NO] IS NULL) OR ([ALIPAY_TRADING_NO] = @Original_ALIPAY_TRADING_NO)) AND ((@IsNull_OTH_ACCOUNT_NO = 1 AND [OTH_ACCOUNT_NO] IS NULL) OR ([OTH_ACCOUNT_NO] = @Original_OTH_ACCOUNT_NO)) AND ((@IsNull_OTH_ACCOUNT_NME = 1 AND [OTH_ACCOUNT_NME] IS NULL) OR ([OTH_ACCOUNT_NME] = @Original_OTH_ACCOUNT_NME)) AND ((@IsNull_CHARGE_SRC_CID = 1 AND [CHARGE_SRC_CID] IS NULL) OR ([CHARGE_SRC_CID] = @Original_CHARGE_SRC_CID)) AND ((@IsNull_TRADING_AMT = 1 AND [TRADING_AMT] IS NULL) OR ([TRADING_AMT] = @Original_TRADING_AMT)) AND ((@IsNull_TRADING_SID = 1 AND [TRADING_SID] IS NULL) OR ([TRADING_SID] = @Original_TRADING_SID)) AND ((@IsNull_TRADING_DESC = 1 AND [TRADING_DESC] IS NULL) OR ([TRADING_DESC] = @Original_TRADING_DESC)) AND ((@IsNull_SUBMIT_PAY_DT = 1 AND [SUBMIT_PAY_DT] IS NULL) OR ([SUBMIT_PAY_DT] = @Original_SUBMIT_PAY_DT)) AND ((@IsNull_PAY_ARRIVE_DT = 1 AND [PAY_ARRIVE_DT] IS NULL) OR ([PAY_ARRIVE_DT] = @Original_PAY_ARRIVE_DT)) AND ((@IsNull_PAY_AFTER_SQL = 1 AND [PAY_AFTER_SQL] IS NULL) OR ([PAY_AFTER_SQL] = @Original_PAY_AFTER_SQL)) AND ((@IsNull_IS_SPLIT = 1 AND [IS_SPLIT] IS NULL) OR ([IS_SPLIT] = @Original_IS_SPLIT)) AND ((@IsNull_INITIAL_DT = 1 AND [INITIAL_DT] IS NULL) OR ([INITIAL_DT] = @Original_INITIAL_DT)) AND ((@IsNull_INITIAL_USR = 1 AND [INITIAL_USR] IS NULL) OR ([INITIAL_USR] = @Original_INITIAL_USR)));
SELECT CHARGE_TRADING_ID, AR_FREIGHT_ID, ACCOUNT_NO, ACCOUNT_NME, USER_TYPE_CID, PAY_DIR, TRADING_NO, TRADING_NME, TRADING_TYPE_CID, ALIPAY_TRADING_NO, OTH_ACCOUNT_NO, OTH_ACCOUNT_NME, CHARGE_SRC_CID, TRADING_AMT, TRADING_SID, TRADING_DESC, SUBMIT_PAY_DT, PAY_ARRIVE_DT, PAY_AFTER_SQL, IS_SPLIT, INITIAL_DT, INITIAL_USR FROM SHP_CHARGE_TRADING_LOG WHERE (CHARGE_TRADING_ID = @CHARGE_TRADING_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHARGE_TRADING_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AR_FREIGHT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AR_FREIGHT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@USER_TYPE_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="USER_TYPE_CID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAY_DIR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_TYPE_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_TYPE_CID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALIPAY_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OTH_ACCOUNT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OTH_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHARGE_SRC_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_SRC_CID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TRADING_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_SID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_SID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SUBMIT_PAY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SUBMIT_PAY_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PAY_ARRIVE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PAY_ARRIVE_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAY_AFTER_SQL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_AFTER_SQL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_SPLIT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_SPLIT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHARGE_TRADING_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AR_FREIGHT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AR_FREIGHT_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AR_FREIGHT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AR_FREIGHT_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ACCOUNT_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ACCOUNT_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_USER_TYPE_CID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="USER_TYPE_CID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_USER_TYPE_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="USER_TYPE_CID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAY_DIR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAY_DIR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_TYPE_CID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_TYPE_CID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_TYPE_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_TYPE_CID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALIPAY_TRADING_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALIPAY_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OTH_ACCOUNT_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OTH_ACCOUNT_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OTH_ACCOUNT_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OTH_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OTH_ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHARGE_SRC_CID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_SRC_CID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHARGE_SRC_CID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_SRC_CID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TRADING_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_SID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_SID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_SID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_SID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_DESC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SUBMIT_PAY_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SUBMIT_PAY_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_SUBMIT_PAY_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SUBMIT_PAY_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAY_ARRIVE_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAY_ARRIVE_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PAY_ARRIVE_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PAY_ARRIVE_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAY_AFTER_SQL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAY_AFTER_SQL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAY_AFTER_SQL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_AFTER_SQL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_SPLIT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_SPLIT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_SPLIT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_SPLIT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_USR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CHARGE_TRADING_ID" DataSetColumn="CHARGE_TRADING_ID" />
              <Mapping SourceColumn="AR_FREIGHT_ID" DataSetColumn="AR_FREIGHT_ID" />
              <Mapping SourceColumn="ACCOUNT_NO" DataSetColumn="ACCOUNT_NO" />
              <Mapping SourceColumn="ACCOUNT_NME" DataSetColumn="ACCOUNT_NME" />
              <Mapping SourceColumn="USER_TYPE_CID" DataSetColumn="USER_TYPE_CID" />
              <Mapping SourceColumn="PAY_DIR" DataSetColumn="PAY_DIR" />
              <Mapping SourceColumn="TRADING_NO" DataSetColumn="TRADING_NO" />
              <Mapping SourceColumn="TRADING_NME" DataSetColumn="TRADING_NME" />
              <Mapping SourceColumn="TRADING_TYPE_CID" DataSetColumn="TRADING_TYPE_CID" />
              <Mapping SourceColumn="ALIPAY_TRADING_NO" DataSetColumn="ALIPAY_TRADING_NO" />
              <Mapping SourceColumn="OTH_ACCOUNT_NO" DataSetColumn="OTH_ACCOUNT_NO" />
              <Mapping SourceColumn="OTH_ACCOUNT_NME" DataSetColumn="OTH_ACCOUNT_NME" />
              <Mapping SourceColumn="CHARGE_SRC_CID" DataSetColumn="CHARGE_SRC_CID" />
              <Mapping SourceColumn="TRADING_AMT" DataSetColumn="TRADING_AMT" />
              <Mapping SourceColumn="TRADING_SID" DataSetColumn="TRADING_SID" />
              <Mapping SourceColumn="TRADING_DESC" DataSetColumn="TRADING_DESC" />
              <Mapping SourceColumn="SUBMIT_PAY_DT" DataSetColumn="SUBMIT_PAY_DT" />
              <Mapping SourceColumn="PAY_ARRIVE_DT" DataSetColumn="PAY_ARRIVE_DT" />
              <Mapping SourceColumn="PAY_AFTER_SQL" DataSetColumn="PAY_AFTER_SQL" />
              <Mapping SourceColumn="IS_SPLIT" DataSetColumn="IS_SPLIT" />
              <Mapping SourceColumn="INITIAL_DT" DataSetColumn="INITIAL_DT" />
              <Mapping SourceColumn="INITIAL_USR" DataSetColumn="INITIAL_USR" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmShpChargeTradingLog" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmShpChargeTradingLog" msprop:Generator_UserDSName="CDmShpChargeTradingLog">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="SHP_CHARGE_TRADING_LOG" msprop:Generator_TableClassName="SHP_CHARGE_TRADING_LOGDataTable" msprop:Generator_TableVarName="tableSHP_CHARGE_TRADING_LOG" msprop:Generator_TablePropName="SHP_CHARGE_TRADING_LOG" msprop:Generator_RowDeletingName="SHP_CHARGE_TRADING_LOGRowDeleting" msprop:Generator_RowChangingName="SHP_CHARGE_TRADING_LOGRowChanging" msprop:Generator_RowEvHandlerName="SHP_CHARGE_TRADING_LOGRowChangeEventHandler" msprop:Generator_RowDeletedName="SHP_CHARGE_TRADING_LOGRowDeleted" msprop:Generator_UserTableName="SHP_CHARGE_TRADING_LOG" msprop:Generator_RowChangedName="SHP_CHARGE_TRADING_LOGRowChanged" msprop:Generator_RowEvArgName="SHP_CHARGE_TRADING_LOGRowChangeEvent" msprop:Generator_RowClassName="SHP_CHARGE_TRADING_LOGRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CHARGE_TRADING_ID" msprop:Generator_ColumnVarNameInTable="columnCHARGE_TRADING_ID" msprop:Generator_ColumnPropNameInRow="CHARGE_TRADING_ID" msprop:Generator_ColumnPropNameInTable="CHARGE_TRADING_IDColumn" msprop:Generator_UserColumnName="CHARGE_TRADING_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AR_FREIGHT_ID" msprop:Generator_ColumnVarNameInTable="columnAR_FREIGHT_ID" msprop:Generator_ColumnPropNameInRow="AR_FREIGHT_ID" msprop:Generator_ColumnPropNameInTable="AR_FREIGHT_IDColumn" msprop:Generator_UserColumnName="AR_FREIGHT_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCOUNT_NO" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_NO" msprop:Generator_ColumnPropNameInRow="ACCOUNT_NO" msprop:Generator_ColumnPropNameInTable="ACCOUNT_NOColumn" msprop:Generator_UserColumnName="ACCOUNT_NO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCOUNT_NME" msprop:Generator_ColumnVarNameInTable="columnACCOUNT_NME" msprop:Generator_ColumnPropNameInRow="ACCOUNT_NME" msprop:Generator_ColumnPropNameInTable="ACCOUNT_NMEColumn" msprop:Generator_UserColumnName="ACCOUNT_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="USER_TYPE_CID" msprop:Generator_ColumnVarNameInTable="columnUSER_TYPE_CID" msprop:Generator_ColumnPropNameInRow="USER_TYPE_CID" msprop:Generator_ColumnPropNameInTable="USER_TYPE_CIDColumn" msprop:Generator_UserColumnName="USER_TYPE_CID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PAY_DIR" msprop:Generator_ColumnVarNameInTable="columnPAY_DIR" msprop:Generator_ColumnPropNameInRow="PAY_DIR" msprop:Generator_ColumnPropNameInTable="PAY_DIRColumn" msprop:Generator_UserColumnName="PAY_DIR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRADING_NO" msprop:Generator_ColumnVarNameInTable="columnTRADING_NO" msprop:Generator_ColumnPropNameInRow="TRADING_NO" msprop:Generator_ColumnPropNameInTable="TRADING_NOColumn" msprop:Generator_UserColumnName="TRADING_NO">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRADING_NME" msprop:Generator_ColumnVarNameInTable="columnTRADING_NME" msprop:Generator_ColumnPropNameInRow="TRADING_NME" msprop:Generator_ColumnPropNameInTable="TRADING_NMEColumn" msprop:Generator_UserColumnName="TRADING_NME">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRADING_TYPE_CID" msprop:Generator_ColumnVarNameInTable="columnTRADING_TYPE_CID" msprop:Generator_ColumnPropNameInRow="TRADING_TYPE_CID" msprop:Generator_ColumnPropNameInTable="TRADING_TYPE_CIDColumn" msprop:Generator_UserColumnName="TRADING_TYPE_CID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ALIPAY_TRADING_NO" msprop:Generator_ColumnVarNameInTable="columnALIPAY_TRADING_NO" msprop:Generator_ColumnPropNameInRow="ALIPAY_TRADING_NO" msprop:Generator_ColumnPropNameInTable="ALIPAY_TRADING_NOColumn" msprop:Generator_UserColumnName="ALIPAY_TRADING_NO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OTH_ACCOUNT_NO" msprop:Generator_ColumnVarNameInTable="columnOTH_ACCOUNT_NO" msprop:Generator_ColumnPropNameInRow="OTH_ACCOUNT_NO" msprop:Generator_ColumnPropNameInTable="OTH_ACCOUNT_NOColumn" msprop:Generator_UserColumnName="OTH_ACCOUNT_NO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OTH_ACCOUNT_NME" msprop:Generator_ColumnVarNameInTable="columnOTH_ACCOUNT_NME" msprop:Generator_ColumnPropNameInRow="OTH_ACCOUNT_NME" msprop:Generator_ColumnPropNameInTable="OTH_ACCOUNT_NMEColumn" msprop:Generator_UserColumnName="OTH_ACCOUNT_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CHARGE_SRC_CID" msprop:Generator_ColumnVarNameInTable="columnCHARGE_SRC_CID" msprop:Generator_ColumnPropNameInRow="CHARGE_SRC_CID" msprop:Generator_ColumnPropNameInTable="CHARGE_SRC_CIDColumn" msprop:Generator_UserColumnName="CHARGE_SRC_CID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRADING_AMT" msprop:Generator_ColumnVarNameInTable="columnTRADING_AMT" msprop:Generator_ColumnPropNameInRow="TRADING_AMT" msprop:Generator_ColumnPropNameInTable="TRADING_AMTColumn" msprop:Generator_UserColumnName="TRADING_AMT" type="xs:decimal" minOccurs="0" />
              <xs:element name="TRADING_SID" msprop:Generator_ColumnVarNameInTable="columnTRADING_SID" msprop:Generator_ColumnPropNameInRow="TRADING_SID" msprop:Generator_ColumnPropNameInTable="TRADING_SIDColumn" msprop:Generator_UserColumnName="TRADING_SID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRADING_DESC" msprop:Generator_ColumnVarNameInTable="columnTRADING_DESC" msprop:Generator_ColumnPropNameInRow="TRADING_DESC" msprop:Generator_ColumnPropNameInTable="TRADING_DESCColumn" msprop:Generator_UserColumnName="TRADING_DESC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SUBMIT_PAY_DT" msprop:Generator_ColumnVarNameInTable="columnSUBMIT_PAY_DT" msprop:Generator_ColumnPropNameInRow="SUBMIT_PAY_DT" msprop:Generator_ColumnPropNameInTable="SUBMIT_PAY_DTColumn" msprop:Generator_UserColumnName="SUBMIT_PAY_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PAY_ARRIVE_DT" msprop:Generator_ColumnVarNameInTable="columnPAY_ARRIVE_DT" msprop:Generator_ColumnPropNameInRow="PAY_ARRIVE_DT" msprop:Generator_ColumnPropNameInTable="PAY_ARRIVE_DTColumn" msprop:Generator_UserColumnName="PAY_ARRIVE_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PAY_AFTER_SQL" msprop:Generator_ColumnVarNameInTable="columnPAY_AFTER_SQL" msprop:Generator_ColumnPropNameInRow="PAY_AFTER_SQL" msprop:Generator_ColumnPropNameInTable="PAY_AFTER_SQLColumn" msprop:Generator_UserColumnName="PAY_AFTER_SQL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3800" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IS_SPLIT" msprop:Generator_ColumnVarNameInTable="columnIS_SPLIT" msprop:Generator_ColumnPropNameInRow="IS_SPLIT" msprop:Generator_ColumnPropNameInTable="IS_SPLITColumn" msprop:Generator_UserColumnName="IS_SPLIT" type="xs:boolean" minOccurs="0" />
              <xs:element name="INITIAL_DT" msprop:Generator_ColumnVarNameInTable="columnINITIAL_DT" msprop:Generator_ColumnPropNameInRow="INITIAL_DT" msprop:Generator_ColumnPropNameInTable="INITIAL_DTColumn" msprop:Generator_UserColumnName="INITIAL_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="INITIAL_USR" msprop:Generator_ColumnVarNameInTable="columnINITIAL_USR" msprop:Generator_ColumnPropNameInRow="INITIAL_USR" msprop:Generator_ColumnPropNameInTable="INITIAL_USRColumn" msprop:Generator_UserColumnName="INITIAL_USR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SHP_CHARGE_TRADING_LOG" />
      <xs:field xpath="mstns:CHARGE_TRADING_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>